﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet_ticketxsd" targetNamespace="http://tempuri.org/DataSet_ticketxsd.xsd" xmlns:mstns="http://tempuri.org/DataSet_ticketxsd.xsd" xmlns="http://tempuri.org/DataSet_ticketxsd.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="Bus_proConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Bus_proConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.Bus_proConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable_ticketTableAdapter" GeneratorDataComponentClassName="DataTable_ticketTableAdapter" Name="DataTable_ticket" UserDataComponentName="DataTable_ticketTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Bus_proConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="ticketFill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="ticketGetData" GeneratorSourceName="ticketFill" GetMethodModifier="Public" GetMethodName="ticketGetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="ticketGetData" UserSourceName="ticketFill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Table_Sale.Sale_id, Table_Sale.Passenger_id, Table_Sale.Sale_date, Table_Sale.Sale_time, Table_Sale.Promotion_id, Table_Sale.Point_id, 
                         Table_Sale.Personnel_id, Table_Sale.Around_id, Table_Sale.SSID, Table_SaleDetail.Seat_id, Table_SaleDetail.Seat_no, Table_SaleDetail.Sale_id AS Expr1, 
                         Table_SaleDetail.Price_ticket, Table_SaleDetail.tex, Table_SaleDetail.Around_id AS Expr2, Table_Around.Around_id AS Expr3, Table_Around.Route_id, 
                         Table_Around.Around_date, Table_Around.Time_id, Table_Around.Bus_Line_id, Table_Around.Type_Bus_id, Table_Route.Route_id AS Expr4, 
                         Table_Route.Route_source, Table_Route.Route_destination, Table_Route.Route_distance, Table_Time.Time_id AS Expr5, Table_Time.Route_id AS Expr6, 
                         Table_Time.Time_time, Table_Type_Bus.Type_Bus_id AS Expr7, Table_Type_Bus.Type_Bus_name, Table_Type_Bus.Type_Bus_number, 
                         Table_Type_Bus.Type_Bus_seat_colum, Table_Type_Bus.Type_Bus_seat_row, Table_Promotion.Promotion_id AS Expr8, 
                         Table_Promotion.Promotion_name, Table_Promotion.Promotion_discount, Table_Promotion.Promotion_distance, Table_Promotion.Promotion_status
FROM            Table_Sale INNER JOIN
                         Table_SaleDetail ON Table_Sale.Sale_id = Table_SaleDetail.Sale_id INNER JOIN
                         Table_Around ON Table_Around.Around_id = Table_Sale.Around_id AND Table_SaleDetail.Around_id = Table_Around.Around_id INNER JOIN
                         Table_Route ON Table_Route.Route_id = Table_Around.Route_id INNER JOIN
                         Table_Time ON Table_Around.Time_id = Table_Time.Time_id INNER JOIN
                         Table_Type_Bus ON Table_Type_Bus.Type_Bus_id = Table_Around.Type_Bus_id INNER JOIN
                         Table_Promotion ON Table_Promotion.Promotion_id = Table_Sale.Promotion_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Sale_id" DataSetColumn="Sale_id" />
              <Mapping SourceColumn="Passenger_id" DataSetColumn="Passenger_id" />
              <Mapping SourceColumn="Sale_date" DataSetColumn="Sale_date" />
              <Mapping SourceColumn="Sale_time" DataSetColumn="Sale_time" />
              <Mapping SourceColumn="Promotion_id" DataSetColumn="Promotion_id" />
              <Mapping SourceColumn="Point_id" DataSetColumn="Point_id" />
              <Mapping SourceColumn="Personnel_id" DataSetColumn="Personnel_id" />
              <Mapping SourceColumn="Around_id" DataSetColumn="Around_id" />
              <Mapping SourceColumn="SSID" DataSetColumn="SSID" />
              <Mapping SourceColumn="Seat_id" DataSetColumn="Seat_id" />
              <Mapping SourceColumn="Seat_no" DataSetColumn="Seat_no" />
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="Price_ticket" DataSetColumn="Price_ticket" />
              <Mapping SourceColumn="tex" DataSetColumn="tex" />
              <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
              <Mapping SourceColumn="Expr3" DataSetColumn="Expr3" />
              <Mapping SourceColumn="Route_id" DataSetColumn="Route_id" />
              <Mapping SourceColumn="Around_date" DataSetColumn="Around_date" />
              <Mapping SourceColumn="Time_id" DataSetColumn="Time_id" />
              <Mapping SourceColumn="Bus_Line_id" DataSetColumn="Bus_Line_id" />
              <Mapping SourceColumn="Type_Bus_id" DataSetColumn="Type_Bus_id" />
              <Mapping SourceColumn="Expr4" DataSetColumn="Expr4" />
              <Mapping SourceColumn="Route_source" DataSetColumn="Route_source" />
              <Mapping SourceColumn="Route_destination" DataSetColumn="Route_destination" />
              <Mapping SourceColumn="Route_distance" DataSetColumn="Route_distance" />
              <Mapping SourceColumn="Expr5" DataSetColumn="Expr5" />
              <Mapping SourceColumn="Expr6" DataSetColumn="Expr6" />
              <Mapping SourceColumn="Time_time" DataSetColumn="Time_time" />
              <Mapping SourceColumn="Expr7" DataSetColumn="Expr7" />
              <Mapping SourceColumn="Type_Bus_name" DataSetColumn="Type_Bus_name" />
              <Mapping SourceColumn="Type_Bus_number" DataSetColumn="Type_Bus_number" />
              <Mapping SourceColumn="Type_Bus_seat_colum" DataSetColumn="Type_Bus_seat_colum" />
              <Mapping SourceColumn="Type_Bus_seat_row" DataSetColumn="Type_Bus_seat_row" />
              <Mapping SourceColumn="Expr8" DataSetColumn="Expr8" />
              <Mapping SourceColumn="Promotion_name" DataSetColumn="Promotion_name" />
              <Mapping SourceColumn="Promotion_discount" DataSetColumn="Promotion_discount" />
              <Mapping SourceColumn="Promotion_distance" DataSetColumn="Promotion_distance" />
              <Mapping SourceColumn="Promotion_status" DataSetColumn="Promotion_status" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet_ticketxsd" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet_ticketxsd" msprop:Generator_UserDSName="DataSet_ticketxsd">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DataTable_ticket" msprop:Generator_TableClassName="DataTable_ticketDataTable" msprop:Generator_TableVarName="tableDataTable_ticket" msprop:Generator_TablePropName="DataTable_ticket" msprop:Generator_RowDeletingName="DataTable_ticketRowDeleting" msprop:Generator_RowChangingName="DataTable_ticketRowChanging" msprop:Generator_RowEvHandlerName="DataTable_ticketRowChangeEventHandler" msprop:Generator_RowDeletedName="DataTable_ticketRowDeleted" msprop:Generator_UserTableName="DataTable_ticket" msprop:Generator_RowChangedName="DataTable_ticketRowChanged" msprop:Generator_RowEvArgName="DataTable_ticketRowChangeEvent" msprop:Generator_RowClassName="DataTable_ticketRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Sale_id" msprop:Generator_ColumnVarNameInTable="columnSale_id" msprop:Generator_ColumnPropNameInRow="Sale_id" msprop:Generator_ColumnPropNameInTable="Sale_idColumn" msprop:Generator_UserColumnName="Sale_id" type="xs:int" />
              <xs:element name="Passenger_id" msprop:Generator_ColumnVarNameInTable="columnPassenger_id" msprop:Generator_ColumnPropNameInRow="Passenger_id" msprop:Generator_ColumnPropNameInTable="Passenger_idColumn" msprop:Generator_UserColumnName="Passenger_id" type="xs:int" minOccurs="0" />
              <xs:element name="Sale_date" msprop:Generator_ColumnVarNameInTable="columnSale_date" msprop:Generator_ColumnPropNameInRow="Sale_date" msprop:Generator_ColumnPropNameInTable="Sale_dateColumn" msprop:Generator_UserColumnName="Sale_date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Sale_time" msprop:Generator_ColumnVarNameInTable="columnSale_time" msprop:Generator_ColumnPropNameInRow="Sale_time" msprop:Generator_ColumnPropNameInTable="Sale_timeColumn" msprop:Generator_UserColumnName="Sale_time" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Promotion_id" msprop:Generator_ColumnVarNameInTable="columnPromotion_id" msprop:Generator_ColumnPropNameInRow="Promotion_id" msprop:Generator_ColumnPropNameInTable="Promotion_idColumn" msprop:Generator_UserColumnName="Promotion_id" type="xs:int" minOccurs="0" />
              <xs:element name="Point_id" msprop:Generator_ColumnVarNameInTable="columnPoint_id" msprop:Generator_ColumnPropNameInRow="Point_id" msprop:Generator_ColumnPropNameInTable="Point_idColumn" msprop:Generator_UserColumnName="Point_id" type="xs:int" minOccurs="0" />
              <xs:element name="Personnel_id" msprop:Generator_ColumnVarNameInTable="columnPersonnel_id" msprop:Generator_ColumnPropNameInRow="Personnel_id" msprop:Generator_ColumnPropNameInTable="Personnel_idColumn" msprop:Generator_UserColumnName="Personnel_id" type="xs:int" minOccurs="0" />
              <xs:element name="Around_id" msprop:Generator_ColumnVarNameInTable="columnAround_id" msprop:Generator_ColumnPropNameInRow="Around_id" msprop:Generator_ColumnPropNameInTable="Around_idColumn" msprop:Generator_UserColumnName="Around_id" type="xs:int" minOccurs="0" />
              <xs:element name="SSID" msprop:Generator_ColumnVarNameInTable="columnSSID" msprop:Generator_ColumnPropNameInRow="SSID" msprop:Generator_ColumnPropNameInTable="SSIDColumn" msprop:Generator_UserColumnName="SSID" type="xs:int" minOccurs="0" />
              <xs:element name="Seat_id" msprop:Generator_ColumnVarNameInTable="columnSeat_id" msprop:Generator_ColumnPropNameInRow="Seat_id" msprop:Generator_ColumnPropNameInTable="Seat_idColumn" msprop:Generator_UserColumnName="Seat_id" type="xs:int" />
              <xs:element name="Seat_no" msprop:Generator_ColumnVarNameInTable="columnSeat_no" msprop:Generator_ColumnPropNameInRow="Seat_no" msprop:Generator_ColumnPropNameInTable="Seat_noColumn" msprop:Generator_UserColumnName="Seat_no" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" type="xs:int" minOccurs="0" />
              <xs:element name="Price_ticket" msprop:Generator_ColumnVarNameInTable="columnPrice_ticket" msprop:Generator_ColumnPropNameInRow="Price_ticket" msprop:Generator_ColumnPropNameInTable="Price_ticketColumn" msprop:Generator_UserColumnName="Price_ticket" type="xs:double" minOccurs="0" />
              <xs:element name="tex" msprop:Generator_ColumnVarNameInTable="columntex" msprop:Generator_ColumnPropNameInRow="tex" msprop:Generator_ColumnPropNameInTable="texColumn" msprop:Generator_UserColumnName="tex" type="xs:double" minOccurs="0" />
              <xs:element name="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" msprop:Generator_UserColumnName="Expr2" type="xs:int" minOccurs="0" />
              <xs:element name="Expr3" msprop:Generator_ColumnVarNameInTable="columnExpr3" msprop:Generator_ColumnPropNameInRow="Expr3" msprop:Generator_ColumnPropNameInTable="Expr3Column" msprop:Generator_UserColumnName="Expr3" type="xs:int" />
              <xs:element name="Route_id" msprop:Generator_ColumnVarNameInTable="columnRoute_id" msprop:Generator_ColumnPropNameInRow="Route_id" msprop:Generator_ColumnPropNameInTable="Route_idColumn" msprop:Generator_UserColumnName="Route_id" type="xs:int" minOccurs="0" />
              <xs:element name="Around_date" msprop:Generator_ColumnVarNameInTable="columnAround_date" msprop:Generator_ColumnPropNameInRow="Around_date" msprop:Generator_ColumnPropNameInTable="Around_dateColumn" msprop:Generator_UserColumnName="Around_date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Time_id" msprop:Generator_ColumnVarNameInTable="columnTime_id" msprop:Generator_ColumnPropNameInRow="Time_id" msprop:Generator_ColumnPropNameInTable="Time_idColumn" msprop:Generator_UserColumnName="Time_id" type="xs:int" minOccurs="0" />
              <xs:element name="Bus_Line_id" msprop:Generator_ColumnVarNameInTable="columnBus_Line_id" msprop:Generator_ColumnPropNameInRow="Bus_Line_id" msprop:Generator_ColumnPropNameInTable="Bus_Line_idColumn" msprop:Generator_UserColumnName="Bus_Line_id" type="xs:int" minOccurs="0" />
              <xs:element name="Type_Bus_id" msprop:Generator_ColumnVarNameInTable="columnType_Bus_id" msprop:Generator_ColumnPropNameInRow="Type_Bus_id" msprop:Generator_ColumnPropNameInTable="Type_Bus_idColumn" msprop:Generator_UserColumnName="Type_Bus_id" type="xs:int" minOccurs="0" />
              <xs:element name="Expr4" msprop:Generator_ColumnVarNameInTable="columnExpr4" msprop:Generator_ColumnPropNameInRow="Expr4" msprop:Generator_ColumnPropNameInTable="Expr4Column" msprop:Generator_UserColumnName="Expr4" type="xs:int" />
              <xs:element name="Route_source" msprop:Generator_ColumnVarNameInTable="columnRoute_source" msprop:Generator_ColumnPropNameInRow="Route_source" msprop:Generator_ColumnPropNameInTable="Route_sourceColumn" msprop:Generator_UserColumnName="Route_source" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Route_destination" msprop:Generator_ColumnVarNameInTable="columnRoute_destination" msprop:Generator_ColumnPropNameInRow="Route_destination" msprop:Generator_ColumnPropNameInTable="Route_destinationColumn" msprop:Generator_UserColumnName="Route_destination" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Route_distance" msprop:Generator_ColumnVarNameInTable="columnRoute_distance" msprop:Generator_ColumnPropNameInRow="Route_distance" msprop:Generator_ColumnPropNameInTable="Route_distanceColumn" msprop:Generator_UserColumnName="Route_distance" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expr5" msprop:Generator_ColumnVarNameInTable="columnExpr5" msprop:Generator_ColumnPropNameInRow="Expr5" msprop:Generator_ColumnPropNameInTable="Expr5Column" msprop:Generator_UserColumnName="Expr5" type="xs:int" />
              <xs:element name="Expr6" msprop:Generator_ColumnVarNameInTable="columnExpr6" msprop:Generator_ColumnPropNameInRow="Expr6" msprop:Generator_ColumnPropNameInTable="Expr6Column" msprop:Generator_UserColumnName="Expr6" type="xs:int" minOccurs="0" />
              <xs:element name="Time_time" msprop:Generator_ColumnVarNameInTable="columnTime_time" msprop:Generator_ColumnPropNameInRow="Time_time" msprop:Generator_ColumnPropNameInTable="Time_timeColumn" msprop:Generator_UserColumnName="Time_time" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expr7" msprop:Generator_ColumnVarNameInTable="columnExpr7" msprop:Generator_ColumnPropNameInRow="Expr7" msprop:Generator_ColumnPropNameInTable="Expr7Column" msprop:Generator_UserColumnName="Expr7" type="xs:int" />
              <xs:element name="Type_Bus_name" msprop:Generator_ColumnVarNameInTable="columnType_Bus_name" msprop:Generator_ColumnPropNameInRow="Type_Bus_name" msprop:Generator_ColumnPropNameInTable="Type_Bus_nameColumn" msprop:Generator_UserColumnName="Type_Bus_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type_Bus_number" msprop:Generator_ColumnVarNameInTable="columnType_Bus_number" msprop:Generator_ColumnPropNameInRow="Type_Bus_number" msprop:Generator_ColumnPropNameInTable="Type_Bus_numberColumn" msprop:Generator_UserColumnName="Type_Bus_number" type="xs:int" minOccurs="0" />
              <xs:element name="Type_Bus_seat_colum" msprop:Generator_ColumnVarNameInTable="columnType_Bus_seat_colum" msprop:Generator_ColumnPropNameInRow="Type_Bus_seat_colum" msprop:Generator_ColumnPropNameInTable="Type_Bus_seat_columColumn" msprop:Generator_UserColumnName="Type_Bus_seat_colum" type="xs:int" minOccurs="0" />
              <xs:element name="Type_Bus_seat_row" msprop:Generator_ColumnVarNameInTable="columnType_Bus_seat_row" msprop:Generator_ColumnPropNameInRow="Type_Bus_seat_row" msprop:Generator_ColumnPropNameInTable="Type_Bus_seat_rowColumn" msprop:Generator_UserColumnName="Type_Bus_seat_row" type="xs:int" minOccurs="0" />
              <xs:element name="Expr8" msprop:Generator_ColumnVarNameInTable="columnExpr8" msprop:Generator_ColumnPropNameInRow="Expr8" msprop:Generator_ColumnPropNameInTable="Expr8Column" msprop:Generator_UserColumnName="Expr8" type="xs:int" />
              <xs:element name="Promotion_name" msprop:Generator_ColumnVarNameInTable="columnPromotion_name" msprop:Generator_ColumnPropNameInRow="Promotion_name" msprop:Generator_ColumnPropNameInTable="Promotion_nameColumn" msprop:Generator_UserColumnName="Promotion_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Promotion_discount" msprop:Generator_ColumnVarNameInTable="columnPromotion_discount" msprop:Generator_ColumnPropNameInRow="Promotion_discount" msprop:Generator_ColumnPropNameInTable="Promotion_discountColumn" msprop:Generator_UserColumnName="Promotion_discount" type="xs:double" minOccurs="0" />
              <xs:element name="Promotion_distance" msprop:Generator_ColumnVarNameInTable="columnPromotion_distance" msprop:Generator_ColumnPropNameInRow="Promotion_distance" msprop:Generator_ColumnPropNameInTable="Promotion_distanceColumn" msprop:Generator_UserColumnName="Promotion_distance" type="xs:int" minOccurs="0" />
              <xs:element name="Promotion_status" msprop:Generator_ColumnVarNameInTable="columnPromotion_status" msprop:Generator_ColumnPropNameInRow="Promotion_status" msprop:Generator_ColumnPropNameInTable="Promotion_statusColumn" msprop:Generator_UserColumnName="Promotion_status" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DataTable_ticket" />
      <xs:field xpath="mstns:Sale_id" />
      <xs:field xpath="mstns:Seat_id" />
      <xs:field xpath="mstns:Expr3" />
      <xs:field xpath="mstns:Expr4" />
      <xs:field xpath="mstns:Expr5" />
      <xs:field xpath="mstns:Expr7" />
      <xs:field xpath="mstns:Expr8" />
    </xs:unique>
  </xs:element>
</xs:schema>